Profiling Report: demographics

Dataset statistics

Number of variables	19
Number of observations	5097
Missing cells	44969
Missing cells (%)	46.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	756.7 KiB
Average record size in memory	152.0 B

Variable types

Text	1
Numeric	13
Unsupported	5

Alerts

`population` is highly overall correlated with `population_male` and 10 other fields	High correlation
`population_male` is highly overall correlated with `population` and 10 other fields	High correlation
`population_female` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_00_09` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_10_19` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_20_29` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_30_39` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_40_49` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_50_59` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_60_69` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_70_79` is highly overall correlated with `population` and 10 other fields	High correlation
`population_age_80_and_older` is highly overall correlated with `population` and 10 other fields	High correlation
`population_male` has 1354 (26.6%) missing values	Missing
`population_female` has 1354 (26.6%) missing values	Missing
`population_rural` has 5097 (100.0%) missing values	Missing
`population_urban` has 5097 (100.0%) missing values	Missing
`population_largest_city` has 5097 (100.0%) missing values	Missing
`population_clustered` has 5097 (100.0%) missing values	Missing
`population_density` has 4590 (90.1%) missing values	Missing
`human_development_index` has 5097 (100.0%) missing values	Missing
`population_age_00_09` has 1354 (26.6%) missing values	Missing
`population_age_10_19` has 1354 (26.6%) missing values	Missing
`population_age_20_29` has 1354 (26.6%) missing values	Missing
`population_age_30_39` has 1354 (26.6%) missing values	Missing
`population_age_40_49` has 1354 (26.6%) missing values	Missing
`population_age_50_59` has 1354 (26.6%) missing values	Missing
`population_age_60_69` has 1354 (26.6%) missing values	Missing
`population_age_70_79` has 1354 (26.6%) missing values	Missing
`population_age_80_and_older` has 1354 (26.6%) missing values	Missing
`location_key` has unique values	Unique
`population_rural` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`population_urban` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`population_largest_city` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`population_clustered` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`human_development_index` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-09-07 23:59:38.344641
Analysis finished	2023-09-07 23:59:52.745786
Duration	14.4 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

location_key
Text

UNIQUE

Distinct	5097
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	39.9 KiB

Length

Max length	11
Median length	11
Mean length	10.935845
Min length	8

Characters and Unicode

Total characters	55740
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5097 ?
Unique (%)	100.0%

Sample

1st row	DE_BB_12051
2nd row	DE_BB_12052
3rd row	DE_BB_12053
4th row	DE_BB_12054
5th row	DE_BB_12060

Value	Count	Frequency (%)
de_bb_12051	1	< 0.1%
de_bb_12067	1	< 0.1%
de_bb_12060	1	< 0.1%
de_bb_12061	1	< 0.1%
de_bb_12062	1	< 0.1%
de_bb_12063	1	< 0.1%
de_bb_12064	1	< 0.1%
de_be_11002	1	< 0.1%
de_bb_12065	1	< 0.1%
de_bb_12068	1	< 0.1%
Other values (5087)	5087	99.8%

Most occurring characters

Value	Count	Frequency (%)
_	10194	18.3%
S	4945	8.9%
0	4799	8.6%
1	4516	8.1%
U	3262	5.9%
2	2794	5.0%
3	2602	4.7%
5	2299	4.1%
7	2028	3.6%
E	1931	3.5%
Other values (27)	16370	29.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	25122	45.1%
Uppercase Letter	20424	36.6%
Connector Punctuation	10194	18.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	4945	24.2%
U	3262	16.0%
E	1931	9.5%
T	1693	8.3%
C	1477	7.2%
N	882	4.3%
A	840	4.1%
D	785	3.8%
M	710	3.5%
I	661	3.2%
Other values (16)	3238	15.9%

Decimal Number

Value	Count	Frequency (%)
0	4799	19.1%
1	4516	18.0%
2	2794	11.1%
3	2602	10.4%
5	2299	9.2%
7	2028	8.1%
4	1765	7.0%
8	1689	6.7%
9	1559	6.2%
6	1071	4.3%

Connector Punctuation

Value	Count	Frequency (%)
_	10194	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35316	63.4%
Latin	20424	36.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	4945	24.2%
U	3262	16.0%
E	1931	9.5%
T	1693	8.3%
C	1477	7.2%
N	882	4.3%
A	840	4.1%
D	785	3.8%
M	710	3.5%
I	661	3.2%
Other values (16)	3238	15.9%

Common

Value	Count	Frequency (%)
_	10194	28.9%
0	4799	13.6%
1	4516	12.8%
2	2794	7.9%
3	2602	7.4%
5	2299	6.5%
7	2028	5.7%
4	1765	5.0%
8	1689	4.8%
9	1559	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55740	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	10194	18.3%
S	4945	8.9%
0	4799	8.6%
1	4516	8.1%
U	3262	5.9%
2	2794	5.0%
3	2602	4.7%
5	2299	4.1%
7	2028	3.6%
E	1931	3.5%
Other values (27)	16370	29.4%

population
Real number (ℝ)

HIGH CORRELATION

Distinct	4779
Distinct (%)	93.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98227.802

Minimum	22
Maximum	10103711
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	22
5-th percentile	247.8
Q1	4872
median	20092
Q3	72816
95-th percentile	403104
Maximum	10103711
Range	10103689
Interquartile range (IQR)	67944

Descriptive statistics

Standard deviation	321366.25
Coefficient of variation (CV)	3.2716425
Kurtosis	320.85824
Mean	98227.802
Median Absolute Deviation (MAD)	18845
Skewness	14.083007
Sum	5.0066711 × 10⁸
Variance	1.0327627 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
145	5	0.1%
158	5	0.1%
187	5	0.1%
167	4	0.1%
179	4	0.1%
92	4	0.1%
357	4	0.1%
196	4	0.1%
244	4	0.1%
169	4	0.1%
Other values (4769)	5054	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22	1	< 0.1%
27	1	< 0.1%
28	1	< 0.1%
36	1	< 0.1%
41	1	< 0.1%
42	1	< 0.1%
46	3	0.1%
48	1	< 0.1%
49	2	< 0.1%
51	1	< 0.1%

Value	Count	Frequency (%)
10103711	1	< 0.1%
8437478	1	< 0.1%
5200821	1	< 0.1%
4657972	1	< 0.1%
4342212	1	< 0.1%
4327184	1	< 0.1%
3460949	1	< 0.1%
3321237	1	< 0.1%
3305408	1	< 0.1%
3250315	1	< 0.1%

population_male
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3626
Distinct (%)	96.9%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	62701.48

Minimum	41
Maximum	4980981
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	41
5-th percentile	1487.1
Q1	6235.5
median	16619
Q3	55830.5
95-th percentile	255700.6
Maximum	4980981
Range	4980940
Interquartile range (IQR)	49595

Descriptive statistics

Standard deviation	177826.1
Coefficient of variation (CV)	2.836075
Kurtosis	258.28756
Mean	62701.48
Median Absolute Deviation (MAD)	12983
Skewness	12.689533
Sum	2.3469164 × 10⁸
Variance	3.1622122 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5741	3	0.1%
10997	3	0.1%
3643	3	0.1%
4799	3	0.1%
5513	3	0.1%
8114	3	0.1%
7408	2	< 0.1%
5386	2	< 0.1%
2157	2	< 0.1%
1007	2	< 0.1%
Other values (3616)	3717	72.9%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41	1	< 0.1%
70	1	< 0.1%
144	1	< 0.1%
222	1	< 0.1%
225	1	< 0.1%
242	1	< 0.1%
246	1	< 0.1%
277	1	< 0.1%
317	1	< 0.1%
318	1	< 0.1%

Value	Count	Frequency (%)
4980981	1	< 0.1%
4025585	1	< 0.1%
2524876	1	< 0.1%
2314349	1	< 0.1%
2140106	1	< 0.1%
2081239	1	< 0.1%
1672189	1	< 0.1%
1670689	1	< 0.1%
1576316	1	< 0.1%
1567002	1	< 0.1%

population_female
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3590
Distinct (%)	95.9%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	64829.592

Minimum	45
Maximum	5122730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	45
5-th percentile	1482.9
Q1	6166.5
median	16701
Q3	56912.5
95-th percentile	269557.6
Maximum	5122730
Range	5122685
Interquartile range (IQR)	50746

Descriptive statistics

Standard deviation	186375.23
Coefficient of variation (CV)	2.8748482
Kurtosis	259.53298
Mean	64829.592
Median Absolute Deviation (MAD)	13266
Skewness	12.764398
Sum	2.4265716 × 10⁸
Variance	3.4735728 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2116	4	0.1%
1545	3	0.1%
5505	3	0.1%
1010	3	0.1%
2393	3	0.1%
21895	2	< 0.1%
2841	2	< 0.1%
8111	2	< 0.1%
1770	2	< 0.1%
407	2	< 0.1%
Other values (3580)	3717	72.9%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
45	1	< 0.1%
63	1	< 0.1%
145	1	< 0.1%
205	1	< 0.1%
230	1	< 0.1%
235	1	< 0.1%
237	1	< 0.1%
247	1	< 0.1%
270	1	< 0.1%
287	1	< 0.1%

Value	Count	Frequency (%)
5122730	1	< 0.1%
4411893	1	< 0.1%
2675945	1	< 0.1%
2343623	1	< 0.1%
2260973	1	< 0.1%
2187078	1	< 0.1%
1790260	1	< 0.1%
1673999	1	< 0.1%
1649048	1	< 0.1%
1607287	1	< 0.1%

population_rural
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	5097
Missing (%)	100.0%
Memory size	39.9 KiB

population_urban
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	5097
Missing (%)	100.0%
Memory size	39.9 KiB

population_largest_city
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	5097
Missing (%)	100.0%
Memory size	39.9 KiB

population_clustered
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	5097
Missing (%)	100.0%
Memory size	39.9 KiB

population_density
Real number (ℝ)

MISSING

Distinct	488
Distinct (%)	96.3%
Missing	4590
Missing (%)	90.1%
Infinite	0
Infinite (%)	0.0%
Mean	476.74004

Minimum	36.2
Maximum	4721.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	36.2
5-th percentile	63.93
Q1	116.45
median	192.2
Q3	499.2
95-th percentile	1998.89
Maximum	4721.9
Range	4685.7
Interquartile range (IQR)	382.75

Descriptive statistics

Standard deviation	644.21986
Coefficient of variation (CV)	1.3513022
Kurtosis	7.1431019
Mean	476.74004
Median Absolute Deviation (MAD)	101.3
Skewness	2.4958858
Sum	241707.2
Variance	415019.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102	3	0.1%
117.6	3	0.1%
140	2	< 0.1%
222.3	2	< 0.1%
145.4	2	< 0.1%
107.2	2	< 0.1%
94.5	2	< 0.1%
55.9	2	< 0.1%
101.5	2	< 0.1%
66.4	2	< 0.1%
Other values (478)	485	9.5%
(Missing)	4590	90.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.2	1	< 0.1%
36.8	1	< 0.1%
39.3	1	< 0.1%
39.8	1	< 0.1%
40.1	1	< 0.1%
40.2	1	< 0.1%
41.5	1	< 0.1%
45.6	1	< 0.1%
47.1	1	< 0.1%
50	1	< 0.1%

Value	Count	Frequency (%)
4721.9	1	< 0.1%
3076.6	1	< 0.1%
3067.3	1	< 0.1%
3061.1	1	< 0.1%
3001.4	1	< 0.1%
2902.3	1	< 0.1%
2817.6	1	< 0.1%
2793.4	1	< 0.1%
2791.3	1	< 0.1%
2741.9	1	< 0.1%

human_development_index
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	5097
Missing (%)	100.0%
Memory size	39.9 KiB

population_age_00_09
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3261
Distinct (%)	87.1%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	14437.204

Minimum	0
Maximum	1228873
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	0
5-th percentile	341.2
Q1	1447.5
median	3911
Q3	12074.5
95-th percentile	56842.7
Maximum	1228873
Range	1228873
Interquartile range (IQR)	10627

Descriptive statistics

Standard deviation	44236.776
Coefficient of variation (CV)	3.0640819
Kurtosis	272.59862
Mean	14437.204
Median Absolute Deviation (MAD)	3061
Skewness	13.339309
Sum	54038455
Variance	1.9568923 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
796	5	0.1%
1402	4	0.1%
1566	4	0.1%
1339	4	0.1%
339	4	0.1%
1240	4	0.1%
302	4	0.1%
375	4	0.1%
1317	4	0.1%
198	3	0.1%
Other values (3251)	3703	72.7%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
24	1	< 0.1%
34	1	< 0.1%
40	1	< 0.1%
46	1	< 0.1%
53	1	< 0.1%
54	1	< 0.1%
55	1	< 0.1%
57	1	< 0.1%
58	1	< 0.1%

Value	Count	Frequency (%)
1228873	1	< 0.1%
1033227	1	< 0.1%
706703	1	< 0.1%
638270	1	< 0.1%
568976	1	< 0.1%
455082	1	< 0.1%
410986	1	< 0.1%
390959	1	< 0.1%
379592	1	< 0.1%
379364	1	< 0.1%

population_age_10_19
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3285
Distinct (%)	87.8%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	15078.247

Minimum	0
Maximum	1252274
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	0
5-th percentile	372.2
Q1	1542
median	4146
Q3	13013.5
95-th percentile	59598.5
Maximum	1252274
Range	1252274
Interquartile range (IQR)	11471.5

Descriptive statistics

Standard deviation	43853.067
Coefficient of variation (CV)	2.9083665
Kurtosis	258.78743
Mean	15078.247
Median Absolute Deviation (MAD)	3272
Skewness	12.773757
Sum	56437877
Variance	1.9230915 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3550	4	0.1%
392	4	0.1%
757	4	0.1%
1270	4	0.1%
836	4	0.1%
834	4	0.1%
2081	4	0.1%
1409	3	0.1%
2570	3	0.1%
2523	3	0.1%
Other values (3275)	3706	72.7%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
25	1	< 0.1%
45	1	< 0.1%
46	1	< 0.1%
51	1	< 0.1%
52	1	< 0.1%
55	1	< 0.1%
57	2	< 0.1%
61	1	< 0.1%
63	1	< 0.1%

Value	Count	Frequency (%)
1252274	1	< 0.1%
903623	1	< 0.1%
662619	1	< 0.1%
629856	1	< 0.1%
591374	1	< 0.1%
472818	1	< 0.1%
408705	1	< 0.1%
407689	1	< 0.1%
403031	1	< 0.1%
368330	1	< 0.1%

population_age_20_29
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3250
Distinct (%)	86.8%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	16786.025

Minimum	1
Maximum	1576001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	1
5-th percentile	294.5
Q1	1405
median	4025
Q3	13959.5
95-th percentile	65944.5
Maximum	1576001
Range	1576000
Interquartile range (IQR)	12554.5

Descriptive statistics

Standard deviation	53160.21
Coefficient of variation (CV)	3.1669326
Kurtosis	332.55792
Mean	16786.025
Median Absolute Deviation (MAD)	3278
Skewness	14.598427
Sum	62830091
Variance	2.8260079 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
344	5	0.1%
685	5	0.1%
997	5	0.1%
185	4	0.1%
877	4	0.1%
1501	4	0.1%
589	4	0.1%
335	4	0.1%
1111	4	0.1%
138	4	0.1%
Other values (3240)	3700	72.6%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%
36	1	< 0.1%
40	1	< 0.1%
42	1	< 0.1%
43	1	< 0.1%
46	1	< 0.1%
48	1	< 0.1%
49	1	< 0.1%

Value	Count	Frequency (%)
1576001	1	< 0.1%
1335914	1	< 0.1%
778618	1	< 0.1%
699611	1	< 0.1%
615607	1	< 0.1%
543614	1	< 0.1%
503162	1	< 0.1%
456526	1	< 0.1%
421150	1	< 0.1%
410536	1	< 0.1%

population_age_30_39
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3233
Distinct (%)	86.4%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	16638.446

Minimum	10
Maximum	1484454
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	10
5-th percentile	319
Q1	1408.5
median	3868
Q3	13662.5
95-th percentile	66578.1
Maximum	1484454
Range	1484444
Interquartile range (IQR)	12254

Descriptive statistics

Standard deviation	52834.043
Coefficient of variation (CV)	3.1754192
Kurtosis	298.70325
Mean	16638.446
Median Absolute Deviation (MAD)	3110
Skewness	13.884594
Sum	62277705
Variance	2.7914361 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
831	5	0.1%
114	5	0.1%
6734	4	0.1%
770	4	0.1%
2053	4	0.1%
756	4	0.1%
1321	4	0.1%
665	4	0.1%
807	4	0.1%
170	4	0.1%
Other values (3223)	3701	72.6%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	1	< 0.1%
15	1	< 0.1%
38	2	< 0.1%
42	1	< 0.1%
44	1	< 0.1%
54	1	< 0.1%
57	2	< 0.1%
58	1	< 0.1%
66	1	< 0.1%
69	2	< 0.1%

Value	Count	Frequency (%)
1484454	1	< 0.1%
1333694	1	< 0.1%
784213	1	< 0.1%
723165	1	< 0.1%
593034	1	< 0.1%
528328	1	< 0.1%
513822	1	< 0.1%
494483	1	< 0.1%
423754	1	< 0.1%
422471	1	< 0.1%

population_age_40_49
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3285
Distinct (%)	87.8%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	16415.35

Minimum	6
Maximum	1362194
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	6
5-th percentile	314.1
Q1	1461.5
median	3895
Q3	13567.5
95-th percentile	66687.2
Maximum	1362194
Range	1362188
Interquartile range (IQR)	12106

Descriptive statistics

Standard deviation	49003.89
Coefficient of variation (CV)	2.985248
Kurtosis	250.44352
Mean	16415.35
Median Absolute Deviation (MAD)	3101
Skewness	12.585596
Sum	61442654
Variance	2.4013812 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
619	5	0.1%
946	4	0.1%
199	4	0.1%
424	4	0.1%
928	4	0.1%
233	4	0.1%
2446	4	0.1%
3808	4	0.1%
637	4	0.1%
1087	4	0.1%
Other values (3275)	3702	72.6%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	1	< 0.1%
9	1	< 0.1%
26	1	< 0.1%
37	1	< 0.1%
42	1	< 0.1%
43	1	< 0.1%
46	2	< 0.1%
48	1	< 0.1%
50	1	< 0.1%
52	2	< 0.1%

Value	Count	Frequency (%)
1362194	1	< 0.1%
1074408	1	< 0.1%
712014	1	< 0.1%
662006	1	< 0.1%
617613	1	< 0.1%
554112	1	< 0.1%
519672	1	< 0.1%
494881	1	< 0.1%
432058	1	< 0.1%
416917	1	< 0.1%

population_age_50_59
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3324
Distinct (%)	88.8%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	17949.091

Minimum	15
Maximum	1309380
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	15
5-th percentile	413
Q1	1743
median	4600
Q3	16209
95-th percentile	73720
Maximum	1309380
Range	1309365
Interquartile range (IQR)	14466

Descriptive statistics

Standard deviation	48527.18
Coefficient of variation (CV)	2.7036009
Kurtosis	227.25751
Mean	17949.091
Median Absolute Deviation (MAD)	3620
Skewness	11.7921
Sum	67183449
Variance	2.3548872 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1220	5	0.1%
486	4	0.1%
295	4	0.1%
332	4	0.1%
246	4	0.1%
2245	3	0.1%
910	3	0.1%
346	3	0.1%
1079	3	0.1%
1085	3	0.1%
Other values (3314)	3707	72.7%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15	1	< 0.1%
20	1	< 0.1%
42	1	< 0.1%
52	2	< 0.1%
71	1	< 0.1%
78	1	< 0.1%
79	1	< 0.1%
81	1	< 0.1%
84	1	< 0.1%
86	1	< 0.1%

Value	Count	Frequency (%)
1309380	1	< 0.1%
1061288	1	< 0.1%
695965	1	< 0.1%
664612	1	< 0.1%
546527	1	< 0.1%
529939	1	< 0.1%
499331	1	< 0.1%
455071	1	< 0.1%
439615	1	< 0.1%
414508	1	< 0.1%

population_age_60_69
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3301
Distinct (%)	88.2%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	14751.427

Minimum	16
Maximum	992699
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	16
5-th percentile	414.1
Q1	1674
median	4258
Q3	13951
95-th percentile	59012
Maximum	992699
Range	992683
Interquartile range (IQR)	12277

Descriptive statistics

Standard deviation	37887.495
Coefficient of variation (CV)	2.5683952
Kurtosis	220.39056
Mean	14751.427
Median Absolute Deviation (MAD)	3301
Skewness	11.56785
Sum	55214592
Variance	1.4354623 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2694	4	0.1%
1602	4	0.1%
531	4	0.1%
481	4	0.1%
1125	3	0.1%
1180	3	0.1%
3087	3	0.1%
247	3	0.1%
3540	3	0.1%
2203	3	0.1%
Other values (3291)	3709	72.8%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	1	< 0.1%
22	1	< 0.1%
31	1	< 0.1%
41	1	< 0.1%
60	1	< 0.1%
75	1	< 0.1%
78	1	< 0.1%
83	1	< 0.1%
90	1	< 0.1%
93	1	< 0.1%

Value	Count	Frequency (%)
992699	1	< 0.1%
864991	1	< 0.1%
547237	1	< 0.1%
501458	1	< 0.1%
439605	1	< 0.1%
404624	1	< 0.1%
364488	1	< 0.1%
334581	1	< 0.1%
326790	1	< 0.1%
325350	1	< 0.1%

population_age_70_79
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3071
Distinct (%)	82.0%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	9495.7481

Minimum	7
Maximum	548702
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	7
5-th percentile	248.1
Q1	1044
median	2621
Q3	8564
95-th percentile	38972.5
Maximum	548702
Range	548695
Interquartile range (IQR)	7520

Descriptive statistics

Standard deviation	23815.958
Coefficient of variation (CV)	2.5080655
Kurtosis	169.1151
Mean	9495.7481
Median Absolute Deviation (MAD)	2056
Skewness	10.271172
Sum	35542585
Variance	5.6719986 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
268	6	0.1%
222	4	0.1%
1643	4	0.1%
235	4	0.1%
1698	4	0.1%
2583	4	0.1%
200	4	0.1%
952	4	0.1%
242	4	0.1%
350	4	0.1%
Other values (3061)	3701	72.6%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	2	< 0.1%
22	1	< 0.1%
38	1	< 0.1%
39	1	< 0.1%
40	1	< 0.1%
47	1	< 0.1%
48	1	< 0.1%
50	1	< 0.1%
54	1	< 0.1%
57	1	< 0.1%

Value	Count	Frequency (%)
548702	1	< 0.1%
505978	1	< 0.1%
406123	1	< 0.1%
324842	1	< 0.1%
303780	1	< 0.1%
282388	1	< 0.1%
250534	1	< 0.1%
198005	1	< 0.1%
192397	1	< 0.1%
186337	1	< 0.1%

population_age_80_and_older
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2713
Distinct (%)	72.5%
Missing	1354
Missing (%)	26.6%
Infinite	0
Infinite (%)	0.0%
Mean	5979.5357

Minimum	0
Maximum	349134
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.9 KiB

Quantile statistics

Minimum	0
5-th percentile	170.1
Q1	603
median	1463
Q3	5087.5
95-th percentile	25601.8
Maximum	349134
Range	349134
Interquartile range (IQR)	4484.5

Descriptive statistics

Standard deviation	15566.849
Coefficient of variation (CV)	2.6033541
Kurtosis	168.82486
Mean	5979.5357
Median Absolute Deviation (MAD)	1115
Skewness	10.303967
Sum	22381402
Variance	2.4232677 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
406	8	0.2%
382	6	0.1%
870	6	0.1%
203	6	0.1%
288	6	0.1%
724	5	0.1%
795	5	0.1%
183	5	0.1%
405	5	0.1%
823	5	0.1%
Other values (2703)	3686	72.3%
(Missing)	1354	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
15	1	< 0.1%
17	1	< 0.1%
20	2	< 0.1%
24	2	< 0.1%
25	1	< 0.1%
27	3	0.1%
29	2	< 0.1%
30	1	< 0.1%
32	3	0.1%

Value	Count	Frequency (%)
349134	1	< 0.1%
324355	1	< 0.1%
288877	1	< 0.1%
236261	1	< 0.1%
192229	1	< 0.1%
183288	1	< 0.1%
152149	1	< 0.1%
119974	1	< 0.1%
117379	1	< 0.1%
116780	1	< 0.1%

Auto

Heatmap
Table

	population	population_male	population_female	population_density	population_age_00_09	population_age_10_19	population_age_20_29	population_age_30_39	population_age_40_49	population_age_50_59	population_age_60_69	population_age_70_79	population_age_80_and_older
population	1.000	1.000	0.999	0.273	0.992	0.994	0.991	0.997	0.997	0.997	0.993	0.987	0.979
population_male	1.000	1.000	0.998	0.270	0.992	0.994	0.992	0.998	0.997	0.996	0.992	0.986	0.978
population_female	0.999	0.998	1.000	0.276	0.992	0.994	0.990	0.996	0.996	0.997	0.993	0.988	0.980
population_density	0.273	0.270	0.276	1.000	0.312	0.270	0.418	0.329	0.248	0.219	0.181	0.221	0.212
population_age_00_09	0.992	0.992	0.992	0.312	1.000	0.997	0.988	0.993	0.988	0.984	0.976	0.966	0.958
population_age_10_19	0.994	0.994	0.994	0.270	0.997	1.000	0.992	0.993	0.990	0.986	0.980	0.970	0.962
population_age_20_29	0.991	0.992	0.990	0.418	0.988	0.992	1.000	0.992	0.986	0.981	0.973	0.964	0.957
population_age_30_39	0.997	0.998	0.996	0.329	0.993	0.993	0.992	1.000	0.996	0.992	0.984	0.976	0.968
population_age_40_49	0.997	0.997	0.996	0.248	0.988	0.990	0.986	0.996	1.000	0.996	0.989	0.983	0.974
population_age_50_59	0.997	0.996	0.997	0.219	0.984	0.986	0.981	0.992	0.996	1.000	0.996	0.991	0.984
population_age_60_69	0.993	0.992	0.993	0.181	0.976	0.980	0.973	0.984	0.989	0.996	1.000	0.996	0.986
population_age_70_79	0.987	0.986	0.988	0.221	0.966	0.970	0.964	0.976	0.983	0.991	0.996	1.000	0.991
population_age_80_and_older	0.979	0.978	0.980	0.212	0.958	0.962	0.957	0.968	0.974	0.984	0.986	0.991	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	location_key	population	population_male	population_female	population_rural	population_urban	population_largest_city	population_clustered	population_density	human_development_index	population_age_00_09	population_age_10_19	population_age_20_29	population_age_30_39	population_age_40_49	population_age_50_59	population_age_60_69	population_age_70_79	population_age_80_and_older
0	DE_BB_12051	72124.0	35617.0	36507.0	NaN	NaN	NaN	NaN	367.4	NaN	6029.0	5183.0	6646.0	9776.0	7690.0	11604.0	10152.0	8681.0	6363.0
1	DE_BB_12052	100219.0	49201.0	51018.0	NaN	NaN	NaN	NaN	609.9	NaN	8542.0	7657.0	10979.0	13671.0	10652.0	15833.0	14258.0	10758.0	7869.0
2	DE_BB_12053	57873.0	28023.0	29850.0	NaN	NaN	NaN	NaN	403.2	NaN	4652.0	4702.0	5977.0	7066.0	6405.0	9325.0	9042.0	6049.0	4655.0
3	DE_BB_12054	178089.0	86179.0	91910.0	NaN	NaN	NaN	NaN	1034.5	NaN	18893.0	15636.0	21671.0	28980.0	23226.0	24768.0	18998.0	14762.0	11155.0
4	DE_BB_12060	182760.0	90615.0	92145.0	NaN	NaN	NaN	NaN	126.8	NaN	16693.0	15671.0	12966.0	23038.0	22973.0	33665.0	27041.0	18553.0	12160.0
5	DE_BB_12061	169067.0	83943.0	85124.0	NaN	NaN	NaN	NaN	76.2	NaN	15377.0	14196.0	12369.0	21416.0	21413.0	30742.0	23868.0	17171.0	12515.0
6	DE_BB_12062	102638.0	50832.0	51806.0	NaN	NaN	NaN	NaN	54.7	NaN	7800.0	8044.0	6330.0	11463.0	12143.0	18962.0	17256.0	11843.0	8797.0
7	DE_BB_12063	161909.0	80121.0	81788.0	NaN	NaN	NaN	NaN	94.6	NaN	14768.0	15191.0	12267.0	19401.0	20906.0	31071.0	22170.0	15921.0	10214.0
8	DE_BB_12064	194328.0	96483.0	97845.0	NaN	NaN	NaN	NaN	91.0	NaN	17410.0	16338.0	12100.0	24176.0	24303.0	37375.0	29789.0	18637.0	14200.0
9	DE_BB_12065	211249.0	104111.0	107138.0	NaN	NaN	NaN	NaN	118.8	NaN	19098.0	19465.0	15309.0	25857.0	27267.0	40053.0	29483.0	20516.0	14201.0

	location_key	population	population_male	population_female	population_rural	population_urban	population_largest_city	population_clustered	population_density	human_development_index	population_age_00_09	population_age_10_19	population_age_20_29	population_age_30_39	population_age_40_49	population_age_50_59	population_age_60_69	population_age_70_79	population_age_80_and_older
5087	US_WY_56027	2392.0	1099.0	1293.0	NaN	NaN	NaN	NaN	NaN	NaN	244.0	228.0	291.0	319.0	285.0	294.0	380.0	208.0	143.0
5088	US_WY_56029	29194.0	14585.0	14609.0	NaN	NaN	NaN	NaN	NaN	NaN	3318.0	3471.0	3092.0	3386.0	2987.0	4000.0	4599.0	2824.0	1517.0
5089	US_WY_56031	8541.0	4318.0	4223.0	NaN	NaN	NaN	NaN	NaN	NaN	939.0	936.0	788.0	903.0	894.0	1283.0	1328.0	945.0	525.0
5090	US_WY_56033	30147.0	15145.0	15002.0	NaN	NaN	NaN	NaN	NaN	NaN	3505.0	3727.0	3349.0	3548.0	3507.0	3951.0	4649.0	2529.0	1382.0
5091	US_WY_56035	9745.0	5240.0	4505.0	NaN	NaN	NaN	NaN	NaN	NaN	1233.0	1165.0	954.0	1270.0	1244.0	1356.0	1330.0	832.0	361.0
5092	US_WY_56037	43464.0	22438.0	21026.0	NaN	NaN	NaN	NaN	NaN	NaN	6334.0	6333.0	5488.0	6734.0	5219.0	5534.0	4815.0	2063.0	944.0
5093	US_WY_56039	23384.0	12133.0	11251.0	NaN	NaN	NaN	NaN	NaN	NaN	2461.0	2245.0	3184.0	4184.0	3404.0	2968.0	2855.0	1435.0	648.0
5094	US_WY_56041	20431.0	10339.0	10092.0	NaN	NaN	NaN	NaN	NaN	NaN	3282.0	3182.0	2179.0	2755.0	2349.0	2567.0	2496.0	1116.0	505.0
5095	US_WY_56043	8010.0	4055.0	3955.0	NaN	NaN	NaN	NaN	NaN	NaN	913.0	1162.0	705.0	938.0	902.0	1101.0	1106.0	752.0	431.0
5096	US_WY_56045	6968.0	3660.0	3308.0	NaN	NaN	NaN	NaN	NaN	NaN	777.0	789.0	728.0	932.0	741.0	1009.0	1068.0	541.0	383.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample